﻿using GemBox.Spreadsheet;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Common.Util
{
    public class Spreadsheet
    {
        private string license = ("Eg61NpI/EXEiykT7VR+T7vdvcFHhmxhg").Decode("Common.Util");
        public Spreadsheet()
        {
            SpreadsheetInfo.SetLicense(license);
        }

        public string FileDirectory { get; set; }

        public object[,] Data
        {
            get
            {
                throw new NotImplementedException();
            }
        }

        public ICollection<DataColumn> Columns
        {
            get
            {
                throw new NotImplementedException();
            }
        }

        public ICollection<DataRow> Rows
        {
            get
            {
                throw new NotImplementedException();
            }
        }

        public static Spreadsheet FromFile(string fileName)
        {
            Spreadsheet result = new Spreadsheet();
            result.FileDirectory = fileName;
            return result;
        }
    }
}
